package com.ruoyi.mapper;


import com.ruoyi.domain.T11;
import com.ruoyi.domain.T11DAO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.sql.Date;
import java.util.List;


@Mapper
public interface T11TMapper {
    @Select("select F1102 ,sum(F1103) as F01103 from T11 where F1104 = #{F1104} group by F1102 order by sum(F1103) desc limit 3")
    List<T11DAO> selectT11(Date F1104);

    int insertT11(T11 t11);
}


